Business Analytics with Excel (I) Get Equipped!: A Multimedia Course on Data Analysis (Series: A Multimedia Introduction to Business Analytics with Excel Book 1) by Z. Justin Ren

Author:Z. Justin Ren [Ren, Z. Justin]
Language: eng
Format: azw3
Published: 2014-03-11T16:00:00+00:00

=MAX(C4:C418)

Excel finds that the maximum change is 19.65%.

(2) Use MATCH function to record the location of this maximum value in column C. MATCH function has the following structure:

MATCH(lookup value, where to look,,[1-the largest value that is <= lookup value, 0- the first value that is exactly matching lookup value, -1 -the smallest value that is >= lookup value])

Here we want to find the exact match, so we enter in cell F5:

=MATCH(F4,C4:C418,0)

Excel returns 407. That is, the maximum return is at the 407th position column C.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.